Experienced KS1 and KS2 teacher currently teaching in Year Six. Specialist Leader for Mathematics across three Local Authorities.
All resources have been tried and tested. I'm open to suggestions and requests and aim to help anyone who requires it.
Please leave feedback and rate my resources.
Experienced KS1 and KS2 teacher currently teaching in Year Six. Specialist Leader for Mathematics across three Local Authorities.
All resources have been tried and tested. I'm open to suggestions and requests and aim to help anyone who requires it.
Please leave feedback and rate my resources.
Applicable for the 2021-2022 WRM assessments.
This resource will save you many hours work when trying to use Assessment for Learning in your class.
There are two QLA grids included in one Excel document for help with Gap Analysis.
Arithmetic
Reasoning
Input the data using the marks from the papers and the grid will change colour to show where a child has been successful or not answered a question correctly, or at all.
The spreadsheet will auto-calculate how successful the whole cohort has been on particular questions. These are linked directly to the WRM small steps so you can see which lessons and steps need to be revised. 30 children can be entered in this document.
The total score thresholds auto-calculate and change colour to help indicate which children are working at approximately an expected standard (EXS) level or a Greater Depth (GDS) level. These thresholds use historical KS2 SATs thresholds to make them as accurate as possible.
Please note, some of the cells are locked for editing so that users do not break the spreadsheet functionality. Passwords will not be given out. However, I am more than happy to assist with any adaptations you need.
Additionally, I am in no way affiliated with White Rose Maths. No White Rose Maths resources are included in this product. Freely available content is linked to within it.
Applicable for the 2021-2022 WRM assessments.
This resource will save you many hours work when trying to use Assessment for Learning in your class.
There are two QLA grids included in one Excel document for help with Gap Analysis.
Arithmetic
Reasoning
Input the data using the marks from the papers and the grid will change colour to show where a child has been successful or not answered a question correctly, or at all.
The spreadsheet will auto-calculate how successful the whole cohort has been on particular questions. These are linked directly to the WRM small steps so you can see which lessons and steps need to be revised. 30 children can be entered in this document.
The total score thresholds auto-calculate and change colour to help indicate which children are working at approximately an expected standard (EXS) level or a Greater Depth (GDS) level. These thresholds use historical KS2 SATs thresholds to make them as accurate as possible.
Please note, some of the cells are locked for editing so that users do not break the spreadsheet functionality. Passwords will not be given out. However, I am more than happy to assist with any adaptations you need.
Additionally, I am in no way affiliated with White Rose Maths. No White Rose Maths resources are included in this product. Freely available content is linked to within it.
Applicable for the 2021-2022 WRM assessments.
This resource will save you many hours work when trying to use Assessment for Learning in your class.
There are two QLA grids included in one Excel document for help with Gap Analysis.
Arithmetic
Reasoning
Input the data using the marks from the papers and the grid will change colour to show where a child has been successful or not answered a question correctly, or at all.
The spreadsheet will auto-calculate how successful the whole cohort has been on particular questions. These are linked directly to the WRM small steps so you can see which lessons and steps need to be revised. 30 children can be entered in this document.
The total score thresholds auto-calculate and change colour to help indicate which children are working at approximately an expected standard (EXS) level or a Greater Depth (GDS) level. These thresholds use historical KS2 SATs thresholds to make them as accurate as possible.
Please note, some of the cells are locked for editing so that users do not break the spreadsheet functionality. Passwords will not be given out. However, I am more than happy to assist with any adaptations you need.
Additionally, I am in no way affiliated with White Rose Maths. No White Rose Maths resources are included in this product. Freely available content is linked to within it.
Applicable for the 2021-2022 WRM assessments.
This resource will save you many hours work when trying to use Assessment for Learning in your class.
There are two QLA grids included in one Excel document for help with Gap Analysis.
Arithmetic
Reasoning
Input the data using the marks from the papers and the grid will change colour to show where a child has been successful or not answered a question correctly, or at all.
The spreadsheet will auto-calculate how successful the whole cohort has been on particular questions. These are linked directly to the WRM small steps so you can see which lessons and steps need to be revised. 30 children can be entered in this document.
The total score thresholds auto-calculate and change colour to help indicate which children are working at approximately an expected standard (EXS) level or a Greater Depth (GDS) level. These thresholds use historical KS2 SATs thresholds to make them as accurate as possible.
Please note, some of the cells are locked for editing so that users do not break the spreadsheet functionality. Passwords will not be given out. However, I am more than happy to assist with any adaptations you need.
Additionally, I am in no way affiliated with White Rose Maths. No White Rose Maths resources are included in this product. Freely available content is linked to within it.
Please leave feedback.
These are excel spreadsheets Gap Analysis documents for the May 2022 Year Six SATs Papers for GPS (including spelling).
**
The sheet totals up the scores automatically and each child’s final score changes colour to reflect their ability.
If their total score for a subject goes green, it means they would have passed the 2022 SATs with that score. If it goes Purple with a White font, it means that child would have achieved a ‘More Able’ score for that tested subject.**
I have also included an instructions and document page, linking to a freely available copy of each test, mark scheme and instructions. Additionally, I have included a link to the conversion tables from RAW Score to Scaled Score.
All a teacher has to do is enter their children’s names and enter the 0’s, 1’s, 2’s or 3’s for each question, which also change colour too for a visual reference. I recommend that a teacher should enter ‘N’ if a child did not attempt that question. This gives an idea of who is not even attempting certain questions, not just whether they got the question wrong.
The sheets are set up for 30 or 90 pupils but more can be added/deleted and instructions are on the first page/sheet. Some cells are locked/protected in this document but the parts that you need to insert yourself are editable, including adding and removing rows. This is so that the formulas/algorithms do not break and render the spreadsheet’s functionalities as broken. This password will not be given out, but I am more than happy to make adaptations or changes for you, provided you show proof of purchase. All of my contact details are in the resource.
I take requests for Gap Analysis Grids. Please leave feedback if you like this resource as I am planning to produce more for each SATs paper going forward, as well as CGP Practice Papers.
Please remember to rate this resource as I made this to save teachers time. Thank-you.
These are excel spreadsheets Gap Analysis documents for the May 2022 Year Six SATs Papers for Reading.
**The sheet totals up the scores automatically and each child’s final score changes colour to reflect their ability.
If their total score for a subject goes green, it means they would have passed the 2019 SATs with that score. If it goes Purple with a White font, it means that child would have achieved a ‘Greater Depth’ score for that tested subject.**
I have also included an instructions and document page, linking to a freely available copy of each test, mark scheme and instructions. Additionally, I have included a link to the conversion tables from RAW Score to Scaled Score.
All a teacher has to do is enter their children’s names and enter the 0’s, 1’s, 2’s or 3’s for each question, which also change colour too for a visual reference. I recommend that a teacher should enter ‘N’ if a child did not attempt that question. This gives an idea of who is not even attempting certain questions, not just whether they got the question wrong.
The sheets are set up for 30 or 90 pupils but more can be added/deleted and instructions are on the first page/sheet. Some cells are locked/protected in this document but the parts that you need to insert yourself are editable. This is so that the formulas/algorithms do not break and render the spreadsheet’s functionalities as broken. This password will not be given out, but I am more than happy to make adaptations or changes for you, provided you show proof of purchase. All of my contact details are in the resource.
I take requests for Gap Analysis Grids. Please leave feedback if you like this resource as I am planning to produce more for each SATs paper going forward, as well as CGP Practice Papers.
Please remember to rate this resource as I made this to save teachers time. Thank-you.
Applicable for the 2021-2022 WRM assessments.
This resource will save you many hours work when trying to use Assessment for Learning in your class.
There are two QLA grids included in one Excel document for help with Gap Analysis.
Arithmetic
Reasoning
Input the data using the marks from the papers and the grid will change colour to show where a child has been successful or not answered a question correctly, or at all.
The spreadsheet will auto-calculate how successful the whole cohort has been on particular questions. These are linked directly to the WRM small steps so you can see which lessons and steps need to be revised. 30 children can be entered in this document.
The total score thresholds auto-calculate and change colour to help indicate which children are working at approximately an expected standard (EXS) level or a Greater Depth (GDS) level. These thresholds use historical KS2 SATs thresholds to make them as accurate as possible.
Please note, some of the cells are locked for editing so that users do not break the spreadsheet functionality. Passwords will not be given out. However, I am more than happy to assist with any adaptations you need.
Additionally, I am in no way affiliated with White Rose Maths. No White Rose Maths resources are included in this product. Freely available content is linked to within it.
Perfect for a Maths coordinator looking to have detailed discussions with class teachers about the specific strengths and areas for development for a whole cohort or individual children, these QLA/Gap Analysis grids for each of the White Rose Maths Autumn term assessments will help you support teachers to draw accurate and impactful conclusions from their assessment data.
So far these resources have been used:
To plan revision for a whole class.
To plan interventions for children
In pupil progress meetings to indicate areas for development.
As part of an evidence base for Ofsted deep dives into Maths
Applicable for the 2021-2022 WRM assessments.
This resource will save you many hours work when trying to use Assessment for Learning in your class.
There are two QLA grids included in one Excel document for help with Gap Analysis.
Arithmetic
Reasoning
Input the data using the marks from the papers and the grid will change colour to show where a child has been successful or not answered a question correctly, or at all.
The spreadsheet will auto-calculate how successful the whole cohort has been on particular questions. These are linked directly to the WRM small steps so you can see which lessons and steps need to be revised. 30 children can be entered in this document.
The total score thresholds auto-calculate and change colour to help indicate which children are working at approximately an expected standard (EXS) level or a Greater Depth (GDS) level. These thresholds use historical KS2 SATs thresholds to make them as accurate as possible.
Please note, some of the cells are locked for editing so that users do not break the spreadsheet functionality. Passwords will not be given out. However, I am more than happy to assist with any adaptations you need.
Additionally, I am in no way affiliated with White Rose Maths. No White Rose Maths resources are included in this product. Freely available content is linked to within it.
A complete bundle of Gap Analysis Grids / QLA (Reading, GPS, Spelling, Arithmetic and Reasoning) for the 2022 KS2 SATs assessments. I have also included links to the papers, the mark schemes and the conversion grids within each spreadsheet.
Please read the description of each individual resource for more information.
A complete bundle of Gap Analysis Grids / QLA (Reading, GPS, Spelling, Arithmetic and Reasoning) for the 2023 KS1 SATs assessments. I have also included links to the papers, the mark schemes and the conversion grids within each spreadsheet.
Please read the description of each individual resource for more information.
These are excel spreadsheets Gap Analysis documents for the 2023 Year Two SATs Papers for Reading.
The sheet totals up the scores automatically and each child’s final score changes colour to reflect their ability.
If their total score for a subject goes green, it means they would have passed the 2023 SATs with that score. If it goes Purple, it means that child would have achieved a ‘Greater Depth’ score for that tested subject.
I have also included an instructions and document page, linking to a freely available copy of each test, mark scheme and instructions. Additionally, I have included a link to the conversion tables from RAW Score to Scaled Score.
All a teacher has to do is enter their children’s names and enter the 0’s, 1’s, 2’s or 3’s for each question, which also change colour too for a visual reference. I recommend that a teacher should enter ‘N’ if a child did not attempt that question. This gives an idea of who is not even attempting certain questions, not just whether they got the question wrong.
The sheets are set up for 30 or 60 pupils but more can be added/deleted and instructions are on the first page/sheet. Some cells are locked/protected in this document but the parts that you need to insert yourself are editable. This is so that the formulas/algorithms do not break and render the spreadsheet’s functionalities as broken.
I take requests for Gap Analysis Grids. Please leave feedback if you like this resource as I am planning to produce more for each SATs paper going forward, as well as CGP Practice Papers.
Please remember to rate this resource as I made this to save teachers time. Thank-you.
These are excel spreadsheet Gap Analysis documents for the 2023 Year Two SATs Papers for Maths .
The sheet totals up the scores automatically and each child’s final score changes colour to reflect their ability.
If their total score for a subject goes green, it means they would have passed the 2023 SATs with that score. If it goes Purple with a White font, it means that child would have achieved a ‘More Able’ score for that tested subject.
I have also included an instructions and document page, linking to a freely available copy of each test, mark scheme and instructions. Additionally, I have included a link to the conversion tables from RAW Score to Scaled Score.
All a teacher has to do is enter their children’s names and enter the 0’s, 1’s or 2’s for each question, which also change colour too for a visual reference. I recommend that a teacher should enter ‘N’ if a child did not attempt that question. This gives an idea of who is not even attempting certain questions, not just whether they got the question wrong.
The sheets are set up for 30 or 60 pupils but more can be added/deleted and instructions are on the first page/sheet. Some cells are locked/protected in this document but the parts that you need to insert yourself are editable. This is so that the formulas/algorithms do not break and render the spreadsheet’s functionalities as broken.
I take requests for Gap Analysis Grids. Please leave feedback if you like this resource as I am planning to produce more for each SATs paper going forward, as well as CGP Practice Papers.
Please remember to rate this resource as I made this to save teachers time. Thank-you.
These are excel spreadsheets Gap Analysis documents for the 2023 Year Two SATs Papers for GPS.
The sheet totals up the scores automatically and each child’s final score changes colour to reflect their ability.
If their total score for a subject goes green, it means they would have passed the 2023 SATs with that score. If it goes Purple, it means that child would have achieved a ‘Greater Depth’ score for that tested subject.
I have also included an instructions and document page, linking to a freely available copy of each test, mark scheme and instructions. Additionally, I have included a link to the conversion tables from RAW Score to Scaled Score.
All a teacher has to do is enter their children’s names and enter the 0’s, 1’s, 2’s or 3’s for each question, which also change colour too for a visual reference. I recommend that a teacher should enter ‘N’ if a child did not attempt that question. This gives an idea of who is not even attempting certain questions, not just whether they got the question wrong.
The sheets are set up for 30 and 60 pupils but more can be added/deleted and instructions are on the first page/sheet. Some cells are locked/protected in this document but the parts that you need to insert yourself are editable. This is so that the formulas/algorithms do not break and render the spreadsheet’s functionalities as broken.
I take requests for Gap Analysis Grids. Please leave feedback if you like this resource as I am planning to produce more for each SATs paper going forward, as well as CGP Practice Papers.
Please remember to rate this resource as I made this to save teachers time. Thank-you.
Quiz Quiz Trade game/activity for a whole class.
56 questions and corresponding answers.
Blue (Easy)
Black (Medium)
Green (Harder)
Purple (Mastery)
Tried and tested, perfect to challenge children in a fun way.
Two diary entries based on the same event (visiting the new school wildlife/garden area)
One is basically written with very little attempt at adding detail, high-level punctuation and complex sentences.
The other is of end of KS2 Standard.
I used this activity to get the children to realize that as teachers, we see pieces of text about the same event but the quality of the texts varies drastically. Which would they rather be writing? Which would I rather be reading? Why? Explain why one is better than the other.
Files are uploaded as Publisher, PDF and Word.
These are excel spreadsheets Gap Analysis documents for the 2016 Year Two SATs Papers for GPS.
The sheet totals up the scores automatically and each child’s final score changes colour to reflect their ability.
If their total score for a subject goes green, it means they would have passed the 2016 SATs with that score. If it goes Green with a yellow font, it means that child would have achieved a ‘More Able’ score for that tested subject.
I have also included an instructions and document page, linking to a freely available copy of each test, mark scheme and instructions. Additionally, I have included a link to the conversion tables from RAW Score to Scaled Score.
All a teacher has to do is enter their children’s names and enter the 0’s, 1’s, 2’s or 3’s for each question, which also change colour too for a visual reference. I recommend that a teacher should enter ‘N’ if a child did not attempt that question. This gives an idea of who is not even attempting certain questions, not just whether they got the question wrong.
The sheets are set up for 32 pupils but more can be added/deleted and instructions are on the first page/sheet. Some cells are locked/protected in this document but the parts that you need to insert yourself are editable. This is so that the formulas/algorithms do not break and render the spreadsheet’s functionalities as broken.
I take requests for Gap Analysis Grids. Please leave feedback if you like this resource as I am planning to produce more for each SATs paper going forward, as well as CGP Practice Papers.
Please remember to rate this resource as I made this to save teachers time. Thank-you.
These are excel spreadsheets Gap Analysis documents for the 2016 Year Two SATs Papers for Maths .
The sheet totals up the scores automatically and each child’s final score changes colour to reflect their ability.
If their total score for a subject goes green, it means they would have passed the 2016 SATs with that score. If it goes Green with a yellow font, it means that child would have achieved a ‘More Able’ score for that tested subject.
I have also included an instructions and document page, linking to a freely available copy of each test, mark scheme and instructions. Additionally, I have included a link to the conversion tables from RAW Score to Scaled Score.
All a teacher has to do is enter their children’s names and enter the 0’s, 1’s, 2’s or 3’s for each question, which also change colour too for a visual reference. I recommend that a teacher should enter ‘N’ if a child did not attempt that question. This gives an idea of who is not even attempting certain questions, not just whether they got the question wrong.
The sheets are set up for 32 pupils but more can be added/deleted and instructions are on the first page/sheet. Some cells are locked/protected in this document but the parts that you need to insert yourself are editable. This is so that the formulas/algorithms do not break and render the spreadsheet’s functionalities as broken.
I take requests for Gap Analysis Grids. Please leave feedback if you like this resource as I am planning to produce more for each SATs paper going forward, as well as CGP Practice Papers.
Please remember to rate this resource as I made this to save teachers time. Thank-you.
These are excel spreadsheets Gap Analysis documents for the 2016 Year Two SATs Papers for Reading.
The sheet totals up the scores automatically and each child’s final score changes colour to reflect their ability.
If their total score for a subject goes green, it means they would have passed the 2016 SATs with that score. If it goes Green with a yellow font, it means that child would have achieved a ‘More Able’ score for that tested subject.
I have also included an instructions and document page, linking to a freely available copy of each test, mark scheme and instructions. Additionally, I have included a link to the conversion tables from RAW Score to Scaled Score.
All a teacher has to do is enter their children’s names and enter the 0’s, 1’s, 2’s or 3’s for each question, which also change colour too for a visual reference. I recommend that a teacher should enter ‘N’ if a child did not attempt that question. This gives an idea of who is not even attempting certain questions, not just whether they got the question wrong.
The sheets are set up for 32 pupils but more can be added/deleted and instructions are on the first page/sheet. Some cells are locked/protected in this document but the parts that you need to insert yourself are editable. This is so that the formulas/algorithms do not break and render the spreadsheet’s functionalities as broken.
I take requests for Gap Analysis Grids. Please leave feedback if you like this resource as I am planning to produce more for each SATs paper going forward, as well as CGP Practice Papers.
Please remember to rate this resource as I made this to save teachers time. Thank-you.